MoreExam
1. Question Content...
EXPLANATION
Answer: X - EXPLANATION Content.
Question1: A data engineer is setting up a Document AI pipeline to extract information from scanned invoices stored in an internal stage named 'invoice_stage'. They have created the stage using 'CREATE STAGE and uploaded several PDF documents. However, when attempting to run the extraction query, they encounter an error message: 'File extension does not match actual mime type. Mime- Type: application/octet-stream'. Additionally, they anticipate a privilege issue might arise for pipeline automation. Which of the following conditions must be met to resolve the current error and ensure proper setup for Document AI extraction and subsequent pipeline creation?
Question2: A compliance officer is reviewing the usage of Snowflake Cortex LLM functions and the Cortex REST API within their organization, specifically focusing on the implementation and impact of Cortex Guard. They observe several instances where 'guardrails' were enabled. Which of the following statements accurately describe the behavior and cost considerations of Cortex Guard when integrated with Snowflake Cortex LLM functions or the Cortex REST API?
Question3: An enterprise is deploying a new RAG application using Snowflake Cortex Search on a large dataset of customer support tickets. The operations team is concerned about managing compute costs and ensuring efficient index refreshes for the Cortex Search Service, which needs to be updated hourly. Which of the following considerations and configurations are relevant for optimizing cost and performance of the Cortex Search Service in this scenario?
Question4: A data engineer is designing an automated data pipeline in Snowflake to process incoming customer feedback documents. The pipeline needs to perform the following steps: 1. Extract the overall sentiment from the feedback text. 2. Generate a concise summary of each feedback document. 3. Extract key entities (e.g., product, issue, customer name) into a structured JSON format using a powerful LLM, ensuring adherence to a predefined schema and graceful error handling. Which of the following Snowflake Cortex features and best practices should the data engineer leverage to build this robust AI-infused pipeline?
Question5: A development team is constructing a Gen AI application using Snowflake Cortex LLM functions, particularly for conversational and text generation tasks. They are concerned about potential high costs due to token consumption. Which of the following strategies would most effectively help minimize token usage and optimize costs when working with these Cortex LLM functions?
Question6: An enterprise is deploying a new RAG application using Snowflake Cortex Search on a large dataset of customer support tickets. The operations team is concerned about managing compute costs and ensuring efficient index refreshes for the Cortex Search Service, which needs to be updated hourly. Which of the following considerations and configurations are relevant for optimizing cost and performance of the Cortex Search Service in this scenario?
Question7: A development team is preparing to deploy a new Retrieval-Augmented Generation (RAG) application written in Python. They intend to use Snowflake AI Observability with the TruLens SDK to capture detailed logs and traces for debugging and performance analysis. Which of the following configurations are essential prerequisites for enabling this logging capability effectively?
Question8: An operations team at a company is implementing a robust governance framework to monitor and optimize the costs associated with their Snowflake Cortex LLM function usage. They need to identify which functions are driving the highest token consumption and overall credit usage to pinpoint areas for cost reduction. Which of the following monitoring tools or methods are appropriate for gaining these insights into Cortex LLM function costs and token consumption?
Question9: A Gen AI specialist is preparing to upload a large volume of diverse documents to an internal stage for Document AI processing. The objective is to extract detailed information, including lists of items and potentially classifying document types, and then automate this process. Which of the following statements represent 'best practices or important considerations/limitations' when preparing documents and setting up the Document AI workflow in Snowflake? (Select ALL that apply.)
Question10: An organization has implemented a strict governance policy where the 'ACCOUNTADMIN' has set the 'CORTEX MODELS ALLOWLIST' to only permit 'gemma-7b' and 'llama3.1-8b' models. A developer then executes the following SQL statements in a Snowflake worksheet using 'TRY COMPLETE (SNOWFLAKE.CORTEX)". Assuming no specific RBAC model object grants are in place for the developer's role, what would be the outcome of these queries? SELECT
Question11: A Data Engineer is responsible for deploying machine learning models using Snowpark Container Services. They need to ensure that a specific role, model_deployer_role, has the appropriate permissions to create a Snowpark Container Service that uses an image from an existing image repository named my_inferenc_ images. Which of the following SQL commands grant the necessary privileges 'on the image repository' for this purpose?
Question12: A data application developer is building a Streamlit chat application within Snowflake. This application uses a RAG pattern to answer user questions about a knowledge base, leveraging a Cortex Search Service for retrieval and an LLM for generating responses. The developer wants to ensure responses are relevant, concise, and structured. Which of the following practices are crucial when integrating Cortex Search with Snowflake Cortex LLM functions like AI_COMPLETE for this RAG chatbot?
Question13: A developer is refining a Document AI extraction process using the '!PREDICT' method and is meticulously examining the JSON output for invoices, which include 'invoice number', 'invoice items', 'tax amount', and 'vendor name'. They also have a detailed internal table of 'product details' to be extracted. To ensure optimal data quality and accurate interpretation of the extracted information, which of the following best practices or characteristics of Document AI's output should the developer consider?
Question14: A data science team is using SNOWFLAKE. CORTEX. CLASSIFY_TEXT to categorize product reviews into detailed segments like 'Bug Report - Critical', 'Feature Request - UI/UX', 'General Praise', or 'Query - Billing Issue'. For highly nuanced reviews, they find the initial classifications lack precision, and they are also concerned about the associated compute costs for processing large volumes of dat a. Which strategies should they employ to optimize classification accuracy and manage costs effectively with this function?
Question15: A development team is implementing a suite of generative AI applications on Snowflake, utilizing both SQL functions and the Cortex REST API. They prioritize content safety and plan to integrate Cortex Guard wherever possible. Considering the various interfaces for interacting with Snowflake Cortex LLMs, which of the following interfaces and functions support the direct use of Cortex Guard via the guardrails' argument or equivalent configuration?
Question16: A data science team is deploying a custom real-time inference service for a fine-tuned LLM using Snowpark Container Services (SPCS). They have a Docker image in their Snowflake image repository. They need to define the service using a YAML specification file. Which of the following are ''essential'' components or configurations that must be included in the 'spec.yaml' file for a long- running service that uses this image, custom environment variables, and requires external access?
Question17: A data engineer is tasked with establishing AI Observability for a generative AI application that integrates with external systems and will undergo continuous improvement. The goal is to compare different iterations of the application efficiently. Which combination of configuration best practices, features, and governance aspects are most relevant for a robust setup of AI Observability within Snowflake for this scenario?
Question18: A data application developer is tasked with building a multi-turn conversational AI application using Streamlit in Snowflake (SiS) that leverages the COMPLETE (SNOWFLAKE. CORTEX) LLM function. To ensure the conversation flows naturally and the LLM maintains context from previous interactions, which of the following is the most appropriate method for handling and passing the conversation history?
Question19: database role. Which of the following 'privileges directly related to the virtual warehouse or task execution' are required for the process invoices_task' to successfully execute the Document AI '!PREDICT' method? (Select ALL that apply.)
Question20: A global enterprise has Snowflake accounts in various regions, including a US East (Ohio) account where a critical application is deployed. They need to use AI_COMPLETE with the claude-3-5-sonnet model for real-time customer support, but this model is not natively available in US East (Ohio) for direct AI_COMPLETE usage. The Snowflake administrator considers enabling cross-region inference. Which statements accurately reflect the considerations and characteristics of cross-region inference in Snowflake Cortex?
Question21: A data pipeline processes thousands of scanned legal contracts daily using a Document AI model via the '!PREDICT function. The process involves fetching presigned URLs for documents from an internal stage using 'GET PRESIGNED URL'. Recently, the pipeline has started failing intermittently, returning the error:The data engineering team confirms network connectivity and privileges are stable. Which of the following is the most likely cause of this issue?
Question22: A data scientist, 'Dl DEV', has been granted theDespite these grants, 'DI_DEV' still receives a 'permission denied' error when attempting to ''prepare'' the Document AI model build in Snowsight. Which 'single missing privilege' is the most likely direct cause of this specific error for Document AI model build preparation?
Question23: A data analyst is tasked with identifying customers who purchased items with similar feature vectors. They have a table products with anto measure similarity. Which of the following statements correctly describe aspects of defining and using vector types or functions in this scenario? (Select all that apply)
Question24: A data team is refining their Cortex Analyst semantic model to improve the accuracy of responses for specific, frequently asked questions and to enable better literal value searches. Consider a semantic model being developed to address these requirements. Which two configurations or features are directly relevant and correctly applied in the semantic model YAML for these purposes?
Question25: A data engineer is designing a new feature for a Retrieval Augmented Generation (RAG)-based application in Snowflake. They plan to store document embeddings and perform semantic similarity searches to retrieve relevant context for an LLM. Which of the following statements about using the VECTOR data type and related functions in Snowflake are true? (Select all that apply.)
Question26: A data application developer is tasked with creating a multi-turn conversational AI application using Streamlit in Snowflake (SiS), which will leverage Snowflake Cortex LLM functions. Considering the core requirements for building such an interactive chat interface and the underlying Snowflake environment, which of the following actions is a fundamental step in setting up the application for stateful conversations?
Question27: Which of the following is a 'direct cause' of this error related to missing schema-level privileges, assuming the model build name is unique and the warehouse is active and accessible?
Question28: A Gen AI Specialist is leveraging Snowflake Document AI to extract specific entities and table data from a large and varied collection of documents. They are aware of potential limitations and want to understand the expected outcomes when processing different types of files. Considering a scenario where a Document AI model build is used with the '!PREDICT' method, which of the following statements accurately describe the expected behavior or potential issues based on Document AI's conditions and limitations?
Question29: A Streamlit application developer wants to use AI_COMPLETE (the latest version of COMPLETE (SNOWFLAKE. CORTEX)) to process customer feedback. The goal is to extract structured information, such as the customer's sentiment, product mentioned, and any specific issues, into a predictable JSON format for immediate database ingestion. Which configuration of the AI_COMPLETE function call is essential for achieving this structured output requirement?
Question30: A developer is integrating a Cortex Fine-tuning pipeline into an automated data workflow and needs to ensure structured outputs and monitor the process effectively. They are also aware of certain architectural limitations within Snowflake. Which of the following statements regarding advanced usage or limitations of Snowflake Cortex Fine-tuning and related LLM functions are accurate? (Select all that apply)
Question31: An administrator has configured the 'CORTEX MODELS ALLOWLIST' parameter to only permit the 'mistral-large? model at the account level. A user with the 'PUBLIC' role, which has been granted 'SNOWFLAKE.CORTEX USER and 'SNOWFLAKE."CORTEX- MODEL-ROLE-LLAMA3.1-70B"' , attempts to execute several 'AI_COMPLETE queries. Which of the following queries will successfully execute?
Question32: A data platform architect is integrating 'SNOWFLAKE.CORTEX.EMBED TEXT 768' into a complex data pipeline for a new search application. The pipeline involves extracting text from various sources, generating embeddings, storing them in Snowflake, and performing semantic searches. Which of the following statements accurately describes a compatibility aspect or limitation when working with 'EMBED TEXT 768' and the resulting 'VECTOR' data type within Snowflake?
Question33: A financial institution is deploying a sentiment analysis application that uses Snowflake Cortex 'SENTIMENT' and 'COMPLETE' functions, with different LLMs, for processing customer feedback. They are using AI Observability (Public Preview) to compare the cost- efficiency of using 'mistral-7b' versus 'claude-3-5-sonnet' as LLM judges for evaluation metrics, and also tracking the overall cost of their AI Observability usage. Which statements accurately reflect the cost implications and monitoring tools for this scenario?
Question34: A new Gen AI specialist is setting up Document AI. They have successfully created the necessary database, schema, and a custom role named 'doc_ai specialist_role'. This custom role has been granted the 'SNOWFLAKE.DOCUMENT INTELLIGENCE CREATOR database role. However, when the specialist attempts to create a new Document AI model build in Snowsight, they receive the error: Unable to create a build on the specified database and schem a. Please check the documentation to learn more.What is the most likely missing privilege for the that is preventing the model build creation?
Question35: A security-conscious data scientist in an Azure East US 2 (Virginia) account wants to fine-tune a mistral -7b model for a specific text summarization task and then deploy it for real-time inference using the Cortex REST API. The mistral-7b base model is natively available for fine-tuning in Azure East US 2 (Virginia). For subsequent inference using the fine-tuned model, they need to understand the regional and cross-region inference considerations. Which of the following statements are correct?
Question36: A data engineering team is building an automated pipeline in Snowflake to process customer reviews. They need to use AI_COMPLETE to extract specific details like product, sentiment, and issue type, and store them in a strictly defined JSON format for seamless downstream integration. They aim to maximize the accuracy of the structured output and manage potential model limitations. Which statements accurately reflect the best practices and characteristics when using AI_COMPLETE with structured outputs for this scenario?
Question37: A financial institution is fine-tuning a llama3.1-70b model within Snowflake Cortex using sensitive internal financial reports to improve sentiment analysis on earnings call transcripts. They need to understand the implications for data privacy, model ownership, and how this fine-tuned model can be managed and shared. Which of the following statements are true regarding this process?
Question38: A team is planning the implementation of a new Document AI solution and needs to be aware of the specific guidelines and limitations concerning naming conventions and task management within Snowflake. A primary concern is to avoid common pitfalls that could lead to errors or unsupported configurations.
Question39: A data engineering team is deploying Snowflake Cortex Analyst to enable natural language queries over their structured SALES_DATA table, which includes columns like PRODUCT_CATEGORY, SALES_AMOUNT, and ORDER_DATE. To maximize the accuracy and trustworthiness of responses for business users, which of the following practices should the team implement when configuring their semantic model?
Question40: After resolving this, they try to process a batch of 1500 documents in a single query using the method, which also fails. Which two issues are most likely contributing to these failures?
Question41: An organization relies on Snowflake Cortex LLM functions and has established a robust model governance policy using the 'CORTEX MODELS_ALLOWLIST parameter. A developer is integrating 'TRY COMPLETE into an application for processing various text inputs. Which of the following statements are correct regarding 'TRY COMPLETE and model access controls?
Question42: A financial analytics team is developing an application to extract specific, structured financial data (e.g., company name, revenue, profit margin) from various news articles using Snowflake Cortex LLM functions. They require the output to strictly conform to a predefined JSON schema and want to ensure robust error handling. Which of the following statements are crucial considerations for achieving this goal?
Question43: A financial institution uses Snowflake Cortex Analyst with strict role-based access control (RBAC) on their Snowflake-hosted LLMs. The security team has granted specific 'CORTEX-MODEL-ROLE application roles to different analyst teams, ensuring they only access approved models. A new requirement arises to enable Azure OpenAI GPT models for Cortex Analyst to leverage a specific feature. An administrator proceeds to execute:Which of the following statements accurately describe the implications of this change?
Question44: A data engineering team is preparing a large corpus of unstructured text documents for a Retrieval Augmented Generation (RAG) application in Snowflake, leveraging Cortex Search and LLM functions. They plan to use SNOWFLAKE.CORTEX.SPLIT_TEXT_RECURSIVE_CHARACTER as part of their data ingestion pipeline. What is the primary benefit of employing this helper function in the context of their RAG workflow?
Question45: A company is planning to process a large volume of legal documents to generate summaries using SNOWFLAKE. CORTEX. SUMMARIZE. Given the scale, they are acutely focused on managing costs and optimizing performance. Which of the following statements are true regarding the cost and performance characteristics of using SNOWFLAKE. CORTEX. SUMMARIZE? (Select all that apply)
Question46: A global marketing team uses Snowflake to manage customer feedback in various languages. They need to translate customer reviews from German ("de") into English ("en") for analysis. The reviews are stored in a table named 'CUSTOMER REVIEWS' in a column called 'REVIEW TEXT'. Which of the following SQL statements correctly applies the 'SNOWFLAKE.CORTEX.TRANSLATE function and what is the expected return type for the translated text?
Question47: A data engineering team needs to establish an automated pipeline in Snowflake to continuously extract 'contract_id' and effective_date' from new PDF contract documents uploaded to an internal stage named They have a pre-trained Document AI model named 'contract_processor'. Which of the following sets of SQL commands correctly configures the necessary Snowflake objects for this automated processing pipeline, including handling file access and initial data loading?
Question48: A data engineering team is building an automated pipeline in Snowflake to process incoming sensor dat a. Each sensor reading includes a 1024-dimensional feature vector, and the team needs to flag readings that are significantly different from a baseline reference vector using VECTOR_L1_DISTANCE. The pipeline uses Snowflake tasks to orchestrate data loading and transformation. Which statement regarding the integration and operational aspects of this pipeline is true?
Question49: A team of data application developers is leveraging Snowflake Copilot to streamline the creation of analytical SQL queries within their Streamlit in Snowflake application. They observe that Copilot sometimes struggles with complex joins or provides suboptimal queries when dealing with a newly integrated, deeply nested dataset. Based on Snowflake's best practices and known limitations, which actions or considerations would help improve Copilot's performance in this scenario?
Question50: A financial institution wants to leverage Snowflake Cortex Agents to build an AI application for complex financial analysis, requiring interaction with both their structured transaction databases and unstructured legal documents, while also ensuring intelligent decision- making throughout the process. Which of the following accurately describe the foundational capabilities of Snowflake Cortex Agents?
Question51: A security audit is being conducted for a financial institution using Snowflake Cortex. Which of the following statements accurately describe Snowflake's data safety and security guarantees concerning whether customer data, metadata, or prompts leave Snowflake's governance boundary to a third-party when using Cortex features, under the default Snowflake configurations for Cortex functions unless otherwise specified?
Question52: A data analyst is setting up a new Cortex Analyst-powered conversational app for business users. They want to understand how the "Suggested Questions" feature behaves under different semantic model configurations to ensure an optimal user experience. Which of the following statements accurately describe the behavior of the "Suggested Questions" feature in Cortex Analyst based on the semantic model configuration?
Question53: A business intelligence team wants to enable non-technical users to query their Snowflake data using natural language for sales analytics reports via Cortex Analyst. They are designing the YAML semantic model. Which of the following statements accurately describe key aspects of designing and utilizing a semantic model for Cortex Analyst?
Question54: Which 'combination of missing schema-level privileges' is explicitly cited in the documentation as a direct cause for this error, assuming a unique model build name?
Question55: A business analyst is using a Cortex Analyst-powered conversational application to query structured data in Snowflake. They initially ask, 'What was the total profit from California last quarter?' and then follow up with, 'What about New York?' The application successfully provides accurate answers to both questions. Which of the following statements explain how Cortex Analyst supports this multi-turn conversational experience and maintains accuracy? (Select all that apply)
Question56: A data scientist is tasked with improving the accuracy of an LLM-powered chatbot that answers user questions based on internal company documents stored in Snowflake. They decide to implement a Retrieval Augmented Generation (RAG) architecture using Snowflake Cortex Search. Which of the following statements correctly describe the features and considerations when leveraging Snowflake Cortex Search for this RAG application?
Question57: An operations team at a company is implementing a robust governance framework to monitor and optimize the costs associated with their Snowflake Cortex LLM function usage. They need to identify which functions are driving the highest token consumption and overall credit usage to pinpoint areas for cost reduction. Which of the following monitoring tools or methods are appropriate for gaining these insights into Cortex LLM function costs and token consumption?
Question58: An ML engineer is developing a RAG application in Python and wants to use the TruLens SDK to trace the distinct phases of its execution, specifically the context retrieval and answer generation steps. They aim to clearly differentiate the tracing of the function responsible for retrieving context.
Question59: A Gen AI developer is implementing a Cortex Search Service for a RAG application and needs to configure the text splitting for optimal performance using SNOWFLAKE.CORTEX.SPLIT_TEXT_RECURSIVE_CHARACTER Which of the following statements represent best practices or outcomes when applying text splitting with this function for Cortex Search in a RAG scenario? (Select all that apply)
Question60: A data engineer is constructing a Retrieval Augmented Generation (RAG) pipeline in Snowflake to allow users to query a large corpus of unstructured customer support transcripts using natural language. The goal is to retrieve relevant transcript snippets and then use a Large Language Model (LLM) to generate an answer. Which sequence of steps and Snowflake components would effectively implement this RAG pipeline?
Question61: A Gen AI Specialist in Snowflake Cortex aims to fine-tune an LLM for enhanced task-specific performance. When creating a fine-tuning job using SNOWFLAKE. CORTEX. FINETUNE( 'CREATE', ... ) , which statement accurately describes the required training data format and a supported base model, aligning with Snowflake's Gen AI principles for leveraging LLMs?
Question62: A data engineering team is setting up a Retrieval Augmented Generation (RAG) application using Snowflake Cortex Search to provide contextual answers from customer support transcripts. The transcripts are stored in a Snowflake table named SUPPORT _ TRANSCRIPTS. Which of the following statements are crucial considerations or accurate facts regarding the initial setup and configuration of the Cortex Search Service for this use case?
Question63: A data application developer is building a Streamlit chat application within Snowflake. This application uses a RAG pattern to answer user questions about a knowledge base, leveraging a Cortex Search Service for retrieval and an LLM for generating responses. The developer wants to ensure responses are relevant, concise, and structured. Which of the following practices are crucial when integrating Cortex Search with Snowflake Cortex LLM functions like AI_COMPLETE for this RAG chatbot?
Question64: An ML Engineer is logging a custom PyCaret model to the Snowflake Model Registry, with the intention of deploying it to Snowpark Container Services (SPCS) for GPU-powered inference. The PyCaret model is wrapped in a 'custom_model.ModelContext'. Which of the following statements correctly describe the considerations for the call and the model's environment?
Question65: A security auditor needs to access and analyze logs generated by Snowflake AI Observability for compliance auditing and to track the activity of generative AI applications. They need to understand how to reliably query this data and its temporal characteristics within Snowflake. Which of the following statements accurately describes the access and characteristics of this logged data?
Question66: A Gen AI developer is implementing a Document AI solution to extract key fields from thousands of diverse PDF reports, which vary significantly in length and complexity. They use the '!PREDICT method with 'GET_PRESIGNED_URL' to process documents from an external stage. After initial testing, they observe two distinct types of errors in the query results:for other, lengthy PDF files. Which two of the following actions should the developer take to resolve these issues?
Question67: A team is developing a critical business intelligence application that leverages Snowflake Cortex Analyst to provide natural language querying capabilities over complex structured dat a. To minimize operational costs while maintaining high accuracy, which of the following strategies are most effective for optimizing the cost efficiency of the Cortex Analyst service?
Question68: A marketing analyst wants to quickly gauge the overall sentiment of customer feedback stored in a Snowflake table called CUSTOMER_FEEDBACK, which has a column FEEDBACK_TEXT. They decide to use the SNOWFLAKE .CORTEX.SENTIMENT function to process a review. Consider the following SQL query for a specific review:Which of the following correctly describes the expected output format and interpretation of the sentiment_score for the given input?
Question69: A Snowflake team observes consistently high token costs from 'SNOWFLAKE.ACCOUNT USAGE.CORTEX_FUNCTIONS_QUERY_USAGE_HISTORY' for a summarization task using the 'mistral- large? model. The task involves summarizing legal documents, which often exceed the context window of common LLMs. To optimize these token-based costs, which strategy should the team prioritize?
Question70: A data science team is developing an internal LLM to classify legal documents. They previously used a general-purpose LLM, but found its performance for their specific legal domain to be inconsistent, leading to high error rates and increased manual review. They decide to fine-tune a model using Snowflake Cortex Fine-tuning to improve accuracy and reduce latency for real-time document classification. Which base model, among those available for fine-tuning via SNOWFLAKE .CORTEX.FINETUNE, is explicitly noted for its low latency and high throughput processing, making it a strong candidate for this use case, especially for multi-page text classification?
Question71: A data engineering team is tasked with creating vector embeddings for a collection of diverse, multilingual research papers for a semantic search application. They need to use 'SNOWFLAKE.CORTEX.EMBED TEXT 1024' and are considering two models: 'snowflake-arctic-embed-l-v2.0' and 'voyage-multilingual-2'. They also need to ensure the resulting embeddings are stored correctly and understand potential text truncation. Which of the following statements correctly describes the application of the 'EMBED TEXT 1024' function for these models and the characteristics of the generated embeddings?
Question72: A data engineer is building a Snowflake data pipeline to ingest customer reviews from a raw staging table into a processed table. For each review, they need to determine the overall sentiment (positive, neutral, negative) and store this as a distinct column. The pipeline is implemented using SQL with streams and tasks to process new dat a. Which Snowflake Cortex LLM function, when integrated into the SQL task, is best suited for this sentiment classification and ensures a structured, single-label output for each review?
Question73: A data engineer is tasked with defining a semantic model for Cortex Analyst to enable natural language queries over sales dat a. They are creating a YAML file to describe the logical structure. Which of the following statements correctly describe the configuration of this semantic model? (Select all that apply)
Question74: A data processing team is using Snowflake Document AI to extract data from incoming supplier invoices. They observe that many documents are failing to process, and successful extractions are taking longer than expected, leading to increased costs. Upon investigation, they find error messages such as. Additionally, their 'X-LARGE virtual warehouse is constantly active, contributing to higher-than-anticipated bills. Which two of the following actions are essential steps to troubleshoot and address the root causes of these processing errors and optimize their Document AI pipeline?
Question75: A developer is building a client application that interacts with a Snowflake Cortex Agent using its REST API. They are implementing multi- turn conversation support. Which of the following is the most critical aspect for maintaining conversational context over multiple API calls?
Question76: A team is designing a complex Gen AI application in Snowflake, which includes components for training a custom LLM, running batch inference, and providing a real-time conversational interface. They plan to leverage Snowpark Container Services (SPCS) for these workloads. Which of the following statements accurately describe the suitable SPCS service design models and important considerations for these different application components? (Select all that apply.)
Question77: A software development team is building a conversational AI application within Snowflake, aiming to provide a dynamic and stateful chat experience for users. The application needs to handle follow-up questions while maintaining context, provide responses with a degree of creative variation, and actively filter out any potentially harmful content. The team utilizes the SNOWFLAKE. CORTEX. COMPLETE (or AI_COMPLETE) function.
Question78: A data scientist is tasked with improving the accuracy of an LLM-powered chatbot that answers user questions based on internal company documents stored in Snowflake. They decide to implement a Retrieval Augmented Generation (RAG) architecture using Snowflake Cortex Search. Which of the following statements correctly describe the features and considerations when leveraging Snowflake Cortex Search for this RAG application?
Question79: An ML Engineer deploys a custom fine-tuned LLM on Snowpark Container Services (SPCS) to process multiple independent text streams, generating structured output. The team observes that some streams fail to process, leading to incomplete results, and they also want to effectively monitor the cost of their deployment. Which actions are appropriate for troubleshooting and cost management in this scenario?
Question80: A development team is creating a new search application using Snowflake Cortex Search. They are currently using a 'snowflake-arctic- embed-I-v2.0' embedding model. After an initial load of 10 million rows, each with approximately 500 tokens of text, they observe a significant 'EMBED_TEXT_TOKENS' cost. They want to minimize these costs for future updates and ongoing operations. Considering their goal to optimize 'EMBED_TEXT_TOKENS' costs, which two strategies should the team prioritize for their Cortex Search Service?
Question81: An administrator has configured the 'CORTEX MODELS ALLOWLIST parameter to only permit the 'mistral-large? model at the account level. A user with the role, which has been granted 'SNOWFLAKE.CORTEX USER and 'SNOWFLAKE."CORTEX- MODEL-ROLE-LLAMA3.1-70B"', attempts to execute several queries. Which of the following queries will successfully execute?
Question82: A Streamlit application developer wants to use AI_COMPLETE (the latest version of COMPLETE (SNOWFLAKE. CORTEX)) to process customer feedback. The goal is to extract structured information, such as the customer's sentiment, product mentioned, and any specific issues, into a predictable JSON format for immediate database ingestion. Which configuration of the AI COMPLETE function call is essential for achieving this structured output requirement?
Question83:
Question84: An ML engineer is working on a Snowflake project that requires storing and comparing high-dimensional feature vectors extracted from customer interaction logs. They need to ensure the vector data type is correctly defined and then perform an inner product calculation.Which of the following statements about defining and using theVECTORdata type andVECTOR_INNER_PRODUCTfunction in Snowflake SQL are correct? (Select all that apply)
Question85: A data engineering manager needs to audit Cortex LLM function costs to identify specific SQL queries that are unexpectedly high in token consumption for the 'llama3.1-8b' model. They require granular analysis of prompt, completion, and guardrail token usage for these queries. Which of the following Snowflake methods or views would provide the necessary insights?
Question86: A data architect is integrating Snowflake Cortex LLM functions into various data enrichment pipelines. To ensure optimal performance, cost-efficiency, and accuracy, which of the following are valid best practices or considerations for these pipelines?
Question87: A data engineering team needs to implement a highly accurate, low-latency solution for classifying specialized technical documents into 50 distinct categories. They are considering fine-tuning a Large Language Model (LLM) within Snowflake Cortex for this task. Which of the following considerations are critical for optimizing the fine-tuned model's performance and minimizing inference latency for production use? (Select all that apply)
Question88: A data operations team is attempting to scale up their Document AI automated pipeline. They are using a Snowflake Task to process a large volume of daily scanned invoices and receipts, which are stored in an internal stage 'financial_docs stage'. The current processing involves documents that are frequently around 75 MB each, and often there are batches exceeding 1 ,200 documents in a single day. The pipeline is failing consistently. Which of the following factors could be contributing to the failures in this Document AI automated pipeline? (Select all that apply.)
Question89: A data application developer is using the Snowflake Cortex COMPLETE function to power a multi-turn conversational AI application. They want to ensure responses are creative but not excessively long, adhere to a specific JSON structure, and are filtered for safety. Given the following SQL query snippet, which statements accurately describe the impact of the specified options?
Question90: A development team is implementing a document retrieval system in Snowflake. They plan to store document embeddings and use VECTOR_L2_DISTANCE to find the most relevant documents for a given query embedding. Considering Snowflake's capabilities, which of the following statements are true regarding the use of vector types and VECTOR_L2_DISTANCE? (Select all that apply)
Question91: An ML engineer is deploying a custom PyTorch-based image classification model, obtained from Hugging Face, to Snowpark Container Services (SPCS). The deployment requires GPU acceleration on a compute pool named 'my_gpu_pool' and specific Python packages ('torch' , 'transformers' , 'opencv-python'). The scenario dictates that 'opencv-python' is only available via PyPl, while 'torch' and 'transformers' can be sourced from either conda-forge or PyPl. The engineer uses the Snowflake Model Registry to log the model. Which of the following and configurations correctly specify the necessary Python dependencies and GPU utilization for this inference service, adhering to Snowflake's recommendations?
Question92: A data scientist is optimising a Cortex Analyst application to improve the accuracy of literal searches within user queries, especially for high-cardinality dimension values. They decide to integrate Cortex Search for this purpose. Which of the following statements are true about this integration and the underlying data types in Snowflake? (Select all that apply)
Question93: A team is developing a Retrieval Augmented Generation (RAG) pipeline in Snowflake, where document chunks are embedded using Cortex AI functions and then retrieved using VECTOR_COSINE_SIMILARITY They are planning their infrastructure and cost management strategy. Which of the following statements correctly describes the cost or performance characteristics of these operations in Snowflake? (Select all that apply)
Question94: A data scientist needs to fine-tune a 'mistral-7b' LLM using Snowflake Cortex for a specific text summarization task. They have prepared a training dataset in a Snowflake table, with text in a column named 'source_text' and the desired summaries in a column named 'expected_summary' . They also want to understand the cost implications. Which SQL statement will correctly initiate the fine-tuning job, and how will the cost be primarily calculated?
Question95: A data engineering team is setting up a Retrieval Augmented Generation (RAG) application using Snowflake Cortex Search to provide contextual answers from customer support transcripts. The transcripts are stored in a Snowflake table named SUPPORT_TRANSCRIPTS. Which of the following statements are crucial considerations or accurate facts regarding the initial setup and configuration of the Cortex Search Service for this use case?
Question96: A data scientist is preparing to log a custom PyCaret classification model into the Snowflake Model Registry. The goal is to deploy this model on Snowpark Container Services (SPCS) for scalable inference. The PyCaret model relies on the 'pycaret' and 'scipy' Python libraries, and the data scientist has local 'sample data.csv' for inferring the model's signature. Which statements are crucial for successfully logging this custom model for eventual SPCS deployment?
Question97: A machine learning team has fine-tuned a llama3.1-70b model for a specialised task using Snowflake Cortex Fine-tuning, named prod_llama_responder. They now need to deploy this model for inference via the Cortex REST API across different Snowflake regions and manage its lifecycle effectively. Which of the following statements regarding the fine-tuned model's deployment, access, and management are accurate?
Question98: A data engineering team needs to configure their Snowflake environment to process documents using AI_PARSE_DOCUMENT and generate text embeddings using EMBED_TEXT_1024 with the voyage-multilingual-2 model. Their Snowflake account is in a region where these specific capabilities or models are only available via cross-region inference. The team needs to ensure these functions work correctly without constant region-specific model selection. Which of the following is the correct configuration action and an important consideration?
Question99: A data engineer is building an AI data pipeline to automatically extract specific sentiment categories from customer reviews using 'AI_COMPLETE. They want the output to be a structured JSON object containing 'food_quality', 'food_taste', 'wait_time', and 'food cost' with their respective sentiments (e.g., 'positive', 'negative', 'neutral'). The engineer aims for high accuracy and ensures that all these fields are present in the output. Which of the following statements correctly describe the approach to achieve this?
Question100: A data engineering team is building a pipeline to process legal documents using Snowflake Cortex functions. They aim to extract specific entities and summarize key clauses while being highly cost-conscious. To optimize token-based costs, which of the following practices should they implement when using Cortex LLM functions?
Question101: A data science team is fine-tuning a mistral-lb model within Snowflake Cortex using proprietary customer interaction logs. Which of the following principles and practices apply to this fine-tuning process concerning data privacy, model ownership, and subsequent inference?
Question102: An 'ACCOUNTADMIN' has configured the 'CORTEX MODELS ALLOWLIST parameter to allow only the 'mistral-large? model. A developer, whose role has been granted 'SNOWFLAKE.CORTEX USER and the specific application role 'SNOWFLAKE."CORTEX- MODEL-ROLE-LLAMA3.1-70B"' , subsequently accesses the Cortex LLM Playground. Which models would be available for selection and successful inference by this user within the Playground?
Question103: A data engineer is working with Snowflake Cortex Analyst to improve its ability to answer natural language questions by precisely identifying product names for filtering. They have decided to integrate a Cortex Search Service with their semantic model to enhance literal search for the 'product_name' dimension. Which of the following configurations within the semantic model's YAML file are valid and effective for this purpose?
Question104: A financial institution uses Snowflake Cortex Analyst with strict role-based access control (RBAC) on their Snowflake-hosted LLMs. The security team has granted specific 'CORTEX-MODEL-ROLE application roles to different analyst teams, ensuring they only access approved models. A new requirement arises to enable Azure OpenAI GPT models for Cortex Analyst to leverage a specific feature. An administrator proceeds to execute:Which of the following statements accurately describe the implications of this change?
Question105: A legal department uses Snowflake to manage and review large volumes of contracts. They need to automate the process of finding specific pieces of information, such as the effective_date or involved_parties, from these unstructured contract texts. They are considering using SNOWFLAKE. CORTEX. EXTRACT_ANSWER. Which characteristic correctly describes the primary intent or behavior of SNOWFLAKE. CORTEX. EXTRACT_ANSWER, distinguishing it from other LLM functions?
Question106: A data scientist is tasked with improving the accuracy of an LLM-powered chatbot that answers user questions based on internal company documents stored in Snowflake. They decide to implement a Retrieval Augmented Generation (RAG) architecture using Snowflake Cortex Search. Which of the following statements correctly describe the features and considerations when leveraging Snowflake Cortex Search for this RAG application?
Question107: A development team is preparing to deploy a new Retrieval-Augmented Generation (RAG) application written in Python. They intend to use Snowflake AI Observability to capture detailed logs and traces for debugging and performance analysis. Which of the following configurations are essential prerequisites for enabling this logging capability effectively?
Question108: A Gen AI Specialist is tasked with implementing a data pipeline to automatically enrich new customer feedback entries with sentiment scores using Snowflake Cortex functions. The new feedback arrives in a staging table, and the enrichment process must be automated and cost-effective. Given the following pipeline components, which combination of steps is most appropriate for setting up this continuous data augmentation process?
Question109: A Data Scientist has a pre-trained PyCaret model and wants to log it into the Snowflake Model Registry for inference. The model requires specific versions of and 'scipy' , and a configuration file 'my_config.json' needs to be packaged with the model for use during inference. Assuming 'sp_session' is an active Snowpark Session, is an instance of 'PyCaretModel' , and 'train_features' is a Pandas DataFrame for which of the following code snippets correctly logs this custom PyCaret model into the Snowflake Model Registry?
Question110: A data governance team is concerned about the consistency and compliance of SQL queries generated by Cortex Analyst for sensitive financial reporting. They need to ensure that all generated SQL for a specific semantic model always includes a 'WHERE' clause that filters data for 'region = 'EMEA" and adheres to 'ISO 8601' date formatting for all date columns, regardless of the user's natural language input. Which of the following approaches is the MOST effective for implementing these strict, overarching requirements within Cortex Analyst's semantic model?
Question111: An AI developer is testing a new RAG application in Snowflake. The application usesin this scenario?
Question112: A data engineering team is implementing a solution using Snowflake Cortex's AI_COMPLETE function to process customer support tickets. They are concerned about sensitive information and ensuring the model's responses are safe, while adhering to Snowflake's data governance principles. Which of the following statements correctly describe the functionality of Cortex Guard and Snowflake's data privacy commitments in this context?
Question113: A development team plans to utilize Snowpark Container Services (SPCS) for deploying a variety of AI/ML workloads, including custom LLMs and GPU-accelerated model training jobs. They are in the process of creating a compute pool and need to select the appropriate instance families and configurations. Which of the following statements about 'CREATE COMPUTE POOL' in SPCS are accurate?
Question114: An operations manager is tasked with monitoring the cost and ensuring compliance for a Cortex Analyst deployment that uses the REST API. They are particularly concerned with accurately tracking credit consumption and understanding the implications of enabling external models. Which of the following statements correctly describe aspects of Cortex Analyst cost and governance?
Question115: A data engineering team is designing a scalable data pipeline in Snowflake that involves processing large text inputs with Cortex AI LLM functions. They want to ensure cost efficiency and prevent queries from failing due to exceeding LLM context window limits. They plan to use SNOWFLAKE. CORTEX. COUNT_TOKENS for pre-validation. Which of the following statements are TRUE about the role and cost of COUNT_TOKENS in this scenario? (Select all that apply)
Question116: A developer has successfully created a Cortex Search Service named transcript _ search service within cortex_search_db. services based on customer support transcripts. They now need to query this service to find support tickets related to 'internet issues' specifically from the 'North America' region, and they only want the single most relevant result. Which of the following SQL commands correctly performs this query?
Question117: A data engineering team has developed a Python-based generative AI application and instrumented its key functions using the TruLens SDK. Their next step is to register this application with Snowflake AI Observability to initiate evaluation runs and capture application traces within Snowflake.
Question118: A data scientist has successfully deployed a Hugging Face sentence transformer model to Snowpark Container Services (SPCS) for GPU-powered inference, making it accessible via an HTTP endpoint. To ensure secure and proper programmatic access to this service from an external application, which of the following statements correctly describe the authentication and access control considerations for calling this public endpoint?
Question119: A data engineering team is designing a pipeline in Snowflake to translate a continuous stream of multi-language customer support tickets into English using 'SNOWFLAKE.CORTEX.TRANSLATE. They are concerned about potential language identification issues and the overall cost implications. Which of the following statements are true regarding the use of 'SNOWFLAKE.CORTEX.TRANSLATE for this scenario? (Select all that apply)
Question120: An administrator has configured the 'CORTEX_MODELS_ALLOWLIST parameter to only permit the 'mistral-large? model at the account level. A user with the 'PUBLIC' role, which has been granted 'SNOWFLAKE.CORTEX USER and 'SNOWFLAKE."CORTEX- MODEL-ROLE-LLAMA3.1-70B"' , attempts to execute several 'AI COMPLETE queries. Which of the following queries will successfully execute?
Question121: A SnowPro-certified engineer is tasked with setting up AI Observability for a new generative AI application built using Snowpark Python. The application relies on external Python libraries (e.g., TruLens SDK components) and will process sensitive financial documents. Which of the following steps are crucial for the successful setup and secure operation of AI Observability within Snowflake, given these considerations?
Question122: A company is developing a RAG application to provide concise and highly relevant answers to user queries from a vast knowledge base of technical documents. They are using Cortex Search for retrieval and are considering different embedding models and text chunking strategies to optimise the system. Which of the following statements about Cortex Search embedding models and RAG best practices are correct? (Select all that apply)
Question123: A data analytics team is building a self-service analytics application using Snowflake Cortex Analyst to allow business users to query sales data with natural language. They are defining a semantic model in YAML to ensure accurate text-to-SQL generation. Which of the following is the most crucial aspect of the semantic model's configuration for Cortex Analyst to effectively translate natural language into SQL for structured data?
Question124: An ML engineer is preparing a Docker image for a custom LLM application that will be deployed to Snowpark Container Services (SPCS). The application uses a mix of packages, some commonly found in the Snowflake Anaconda channel and others from general open-source repositories like PyPI. They have the following Docker-file snippet and need to ensure the dependencies are correctly installed for the SPCS environment to support a GPU workload. Which of the following approaches for installing Python packages in the Dockerfile would ensure a robust and compatible setup for a custom LLM running in Snowpark Container Services, based on best practices for managing dependencies in this environment?
Question125: A development team is building a conversational application with Snowflake Cortex Analyst to allow business users to ask follow-up questions about structured dat a. They are specifically designing the multi-turn conversation support and considering the underlying LLM choices for components like the summarization agent. Which of the following statements accurately reflects how Cortex Analyst handles conversational context and best practices for selecting an LLM for its summarization agent?
Question126: A machine learning engineer is building a product recommendation system in Snowflake that uses item embeddings and customer query embeddings for similarity matching. They plan to use the VECTOR_L1_DISTANCE function to find the closest products to a user's query. Which statement accurately describes the cost and data type considerations for this approach?
Question127:
Question128: A data scientist has developed a Hugging Face sentence transformer model for semantic search and needs to deploy it for GPU- powered inference using Snowpark Container Services (SPCS) in Snowflake. They've already trained the SentenceTransformer model locally. Which of the following statements correctly describe essential considerations for logging and deploying this model, ensuring it leverages GPU resources and appropriate dependencies?
Question129: A financial institution wants to automate the extraction of key entities (e.g., invoice number, total amount, list of invoice items) from incoming PDF financial statements into a structured JSON format within their Snowflake data pipeline. The extracted data must conform to a specified JSON schema for seamless downstream integration. Which Snowflake Cortex capabilities, when combined, can best achieve this data augmentation and ensure schema adherence in a continuous processing pipeline?
Question130: A Snowflake account administrator in an Azure East US 2 region needs to enable users to access a new, highly capable LLM, 'claude-3-5-sonnet' , which is currently only natively available in AWS regions via Snowflake Cortex. The administrator also wants to ensure that only specific, approved LLMs can be used across the organization. Which configuration steps are necessary for the administrator to achieve these requirements?
Question131: A Gen AI Specialist needs to extract the 'invoice number' and 'total_amount' from a specific invoice PDF, 'invoice_001 .pdf, located in an internal stage named They want to use the default (latest) model build version for a model named 'invoice_processor'. Which SQL query correctly uses the '!PREDICT method to extract the required information, and what key fields would be present in the JSON output for a successful extraction of 'invoice_number' and 'total_amount'?
Question132: A data scientist is tasked with improving the accuracy of an LLM-powered chatbot that answers user questions based on internal company documents stored in Snowflake. They decide to implement a Retrieval Augmented Generation (RAG) architecture using Snowflake Cortex Search. Which of the following statements correctly describe the features and considerations when leveraging Snowflake Cortex Search for this RAG application?
Question133: A Snowflake administrator needs to configure Snowflake Copilot for a team distributed across different geographical regions, some of which are not natively supported for Copilot. Additionally, the team requires Copilot to adopt a specific tone in its responses. Which of the following correctly outlines the configuration steps for these requirements?
Question134: A development team is preparing to deploy a new Retrieval-Augmented Generation (RAG) application written in Python. They intend to use Snowflake AI Observability to capture detailed logs and traces for debugging and performance analysis. Which of the following configurations are essential prerequisites for enabling this logging capability effectively?
Question135: An ML engineer is designing a Cortex Agent to provide highly accurate and contextualized responses. They intend for the agent to use state-of-the-art LLMs for orchestration and to maintain a specific brand tone in its outputs. Considering the available models and configurations for Cortex Agents, which statement is true?
Question136: A data scientist is leveraging various Snowflake Cortex LLM functions to process extensive text data for an application. To effectively manage their budget, they need a clear understanding of how costs are incurred for each specific function. Which of the following statements accurately describe how costs are calculated for Snowflake Cortex LLM functions, with a particular focus on token usage?
Question137: A development team is building an AI-powered data pipeline in Snowflake. The pipeline involves extracting text from documents, generating embeddings using,and then performing similarity searches usingto find related documents. They plan to manage this pipeline using Snowflake tasks and want to integrate with a Python application for some custom processing. Considering this scenario, which of the following statements about implementing this pipeline are true?
Question138: A data science team is fine-tuning a Snowflake Document AI model to improve the extraction accuracy of specific fields from a new type of complex legal document. They are consistently observing low confidence scores and inconsistent 'value' keys for extracted entities, even after initial training. Which two of the following best practices should the team follow to most effectively improve the model's extraction accuracy and confidence for this complex document type?
Question139: An ML engineer is planning a fine-tuning project for allama3.1-8bmodel to summarize long customer support tickets. They are considering the impact of dataset size and max_epochs on cost and performance, as well as the behavior of the fine-tuned model for inference. Which statements about cost and performance in Snowflake Cortex Fine-tuning are true? (Select all that apply)
Question140: A Streamlit application developer wants to use AI_COMPLETE (the latest version of COMPLETE (SNOWFLAKE.CORTEX)) to process customer feedback. The goal is to extract structured information, such as the customer's sentiment, product mentioned, and any specific issues, into a predictable JSON format for immediate database ingestion. Which configuration of the AI_COMPLETE function call is essential for achieving this structured output requirement?
Question141: An ML engineer is deploying a custom PyTorch-based image classification model, obtained from Hugging Face, to Snowpark Container Services (SPCS). The deployment requires GPU acceleration on a compute pool named 'my_gpu_pool' and specific Python packages ('torch', 'transformerS, 'opencv-python'). The scenario dictates that 'opencv-python' is only available via PyPI, while 'torch' and 'transformers' can be sourced from either conda-forge or PyPI. The engineer uses the Snowflake Model Registry to log the model. Which of the following 'log model' and 'create_service' configurations correctly specify the necessary Python dependencies and GPU utilization for this inference service, adhering to Snowflake's recommendations?
Question142: A machine learning team is leveraging the Snowflake Model Registry to manage diverse models, including a custom Python utility for data preprocessing that they wish to make available as a model method. Which of the following statements accurately describe capabilities or considerations when logging models and their associated artifacts and methods in the Model Registry?
Question143: A data science team is planning to implement a new RAG (Retrieval Augmented Generation) application using Snowflake Cortex, specifically leveraging Cortex Search. They are evaluating the key features, best practices, and cost considerations associated with Cortex Search. Which of the following statements accurately describe aspects of Cortex Search?
Question144: A data application developer is tasked with building a multi-turn conversational AI application using Streamlit in Snowflake (SiS) that leverages the COMPLETE (SNOWFLAKE. CORTEX) LLM function. To ensure the conversation flows naturally and the LLM maintains context from previous interactions, which of the following is the most appropriate method for handling and passing the conversation history?
Question145: A new ML Engineer, 'data_scientist_role' , has been assigned to a project involving custom machine learning models in Snowflake. They need to gain the necessary permissions to perform the following actions related to Snowflake Model Registry and Snowpark Container Services: 1. Log a custom model into a specified schem a. 2. Deploy that model to an existing Snowpark Container Service compute pool. 3. Call the deployed model for inference using SQL. Which of the following SQL commands grant the 'minimal' required privileges to the for these actions, assuming the compute pool and image repository already exist and are appropriately configured?
Question146: A Snowflake administrator needs to implement a granular access control strategy for LLMs. The general policy is to restrict access to a select few models via an account-level allowlist. However, a specific data science team (using role 'DATA SCIENCE TEAM ROLE) requires access to the 'claude-3-5-sonnet' model, which should not be available to other users or globally via the allowlist. Given this scenario, which set of commands would correctly establish this access control while adhering to the specified requirements?
Question147: A Snowflake developer is tasked with enhancing a daily data pipeline. The pipeline processes raw text descriptions of system events and needs to extract structured information, specifically the (string) and its (string, restricted to 'low', 'medium', 'high', 'critical'). The output must be a strictly formatted JSON object, ensuring data quality for downstream analytics.Consider the following SQL snippet intended for this transformation:Which of the following statements are correct regarding this implementation and best practices for using with structured outputs in a data pipeline?
Question148: A data engineering team is setting up a pipeline to automatically process various document types using AI_PARSE_DOCUMENT from an internal stage. Before writing any SQL, they need to ensure their Snowflake environment and the role they will use have the necessary permissions and configurations. Which of the following statements correctly describe essential prerequisites or access control requirements for successfully using AI_PARSE_DOCUMENT in this setup?
Question149: A data engineering manager needs to audit Cortex LLM function costs to identify specific SQL queries that are unexpectedly high in token consumption for the 'llama3.1-8b' model. They require granular analysis of prompt, completion, and guardrail token usage for these queries. Which of the following Snowflake methods or views would provide the necessary insights?
Question150: A data engineer is reviewing the purpose of AI Observability's tracing feature within Snowflake Cortex. Which of the following statements accurately describe the benefits or functionality of tracing in this context?
Question151: An organization is building a new knowledge base system within Snowflake, which relies on 'SNOWFLAKE.CORTEX.EMBED_TEXT_1024' to generate and store embeddings for documents in a 'VECTOR(FLOAT, 1024)' column. They plan to use these embeddings for semantic search and integrate them into various data processing workflows. Which of the following statements accurately describe limitations or specific compatibility aspects of 'EMBED TEXT 1024' or the 'VECTOR' data type within Snowflake?
Question152: A financial analyst is concerned about the rising costs of their Document AI pipeline, which uses 'invoice_model!PREDlCT' to extract data from daily financial reports. They observe that their assigned 'LARGE virtual warehouse is running continuously, even during periods of low document ingestion, contributing significantly to their bill. They want to investigate how to reduce costs effectively for their existing Document AI setup.
Question153: A multi-national corporation uses Snowflake across several AWS regions. Their primary operational Snowflake account is in AWS US East (Ohio), but they need to leverage a specific AI_COMPLETE model, llama4-maverick, which is natively available in AWS US East 1 (N. Virginia) but not in US East (Ohio). To address this, the Snowflake administrator enables cross-region inference for their US East (Ohio) account.
Question154: A developer is building an interactive chat application in Snowflake leveraging the COMPLETE (SNOWFLAKE. CORTEX) LLM function to power multi-turn conversations. To ensure the LLM maintains conversational context and generates coherent responses based on prior interactions, which of the following methods correctly implements the passing of conversation history to the COMPLETE function?
Question155: A Snowflake administrator is tasked with ensuring that a specific data science team can only use approved LLMs (mistral-7b, llama3.1-8b) for generative AI tasks within a particular schema, and also needs to enable the use of an LLM in a non-native region due to specific project requirements. Which combination of configurations would meet these requirements?
Question156: A machine learning engineering team is evaluating two different configurations of a Retrieval Augmented Generation (RAG) application. uses for generation, while uses 'mistral-7b' with a refined prompt for the same task. They aim to compare the and 'groundedness' of the generated responses, as well as the efficiency of context retrieval. Which of the following steps are crucial for setting up AI Observability in Snowflake to facilitate a meaningful side-by-side comparison and assess these specific metrics?
Question157: An ML Engineer has developed a custom PyTorch model for GPU-powered inference and successfully built an OCI-compliant image locally. They now need to push this image to a Snowflake image repository and configure a Snowpark Container Service to use it. The Snowflake account identifier is my org_name_my_account_id_prod. Which set of commands correctly demonstrates tagging the local image and pushing it to the repository?
Question158: An organization is implementing a two-tier LLM access control strategy in Snowflake. First, common models like 'mistral-7b' and 'llama3.1-8b' need to be broadly accessible to all users granted the 'SNOWFLAKE-CORTEX USER database role. Second, a specialized data science team, using the ANALYST ROLE', requires exclusive access to the higher-capability 'claude-3-5- sonnet' model, which should NOT be generally available through the broad access mechanism. Which set of SQL commands, executed by the 'ACCOUNTADMIN" role, correctly establishes this access control strategy?
Question159: A business intelligence team wants to enable non-technical users to query structured data in Snowflake using natural language. They are considering Cortex Analyst. What is the primary role of a semantic model in Cortex Analyst to achieve this goal for structured/text-to-SQL use cases?
Question160: A global enterprise has Snowflake accounts in various regions, including a US East (Ohio) account where a critical application is deployed. They need to use AI_COMPLETE with the claude-3-5-sonnet model for real-time customer support, but this model is not natively available in US East (Ohio) for direct AI_COMPLETE usage. The Snowflake administrator considers enabling cross-region inference. Which statements accurately reflect the considerations and characteristics of cross-region inference in Snowflake Cortex?
Question161:
Question162: An ML engineer has developed a custom PyCaret classification model and wants to deploy it to Snowpark Container Services (SPCS) for inference using the Snowflake Model Registry. The model requires specific versions of pycaret' , 'scipy', and 'joblib'. The engineer also wants to make the service accessible via an HTTP endpoint. Which of the following Model Registry and service creation steps are 'most appropriate' for the ML engineer? (Select all that apply.)
Question163: A security architect is configuring access controls for a new custom role, 'document_processor_role' , which will manage Document AI operations within a designated database 'doc_processing_db' and schema 'doc_workflow_schema'. The goal is to grant only the minimum essential database-level role required to begin working with Document AI features.
Question164: A data engineering team is planning to build a real-time data pipeline using Snowflake's dynamic tables to process incoming log dat a. They want to use SNOWFLAKE. CORTEX. EXTRACT_ANSWER to pull out specific error codes and timestamps from log entries. They are also mindful of the operational costs. Which of the following statements accurately describes limitations or cost considerations for using SNOWFLAKE . CORTEX. EXTRACT_ANSWER in this scenario?
Question165: A data engineer is tasked with establishing a robust MLOps pipeline using the Snowflake Model Registry. They have trained a scikit-learn model and need to log it. Which of the following statements correctly describes a 'required' step or privilege for successfully logging a model using the 'Registry.log_model' method?
Question166:
Question167: A financial analytics team is using AI_COMPLETE to extract specific financial metrics (e.g., revenue, profit margin) from quarterly reports and requires the output in a strict JSON format for automated ingestion into a data warehouse. They've encountered issues where the LLM sometimes generates malformed JSON or includes extraneous text. Which of the following approaches will help ensure deterministic, schema-compliant JSON outputs and mitigate these 'hallucinations' related to format?
Question168: A financial analytics team is using to extract specific financial metrics (e.g., revenue, profit margin) from quarterly reports and requires the output in a strict JSON format for automated ingestion into a data warehouse. They've encountered issues where the LLM sometimes generates malformed JSON or includes extraneous text. Which of the following approaches will help ensure deterministic, schema-compliant JSON outputs and mitigate these 'hallucinations' related to format?
Question169: A Gen AI specialist is preparing to upload a large volume of diverse documents to an internal stage for Document AI processing. The objective is to extract detailed information, including lists of items and potentially classifying document types, and then automate this process. Which of the following statements represent 'best practices or important considerations/limitations' when preparing documents and setting up the Document AI workflow in Snowflake? (Select ALL that apply.)
Question170: A business team using a Snowflake Cortex Analyst-powered chatbot reports that follow-up questions in multi-turn conversations are sometimes slow to process, impacting user experience. The development team wants to optimize for responsiveness while maintaining accuracy in SQL generation. Which of the following strategies directly addresses latency in multi-turn conversations within Cortex Analyst, considering its underlying mechanisms?
Question171: A financial services company uses Snowflake Cortex's AI_COMPLETE for sentiment analysis on customer call transcripts, which contain personally identifiable information (PII). They also fine-tune a llama3.1-70b model with proprietary financial data. Which of the following statements accurately describe Snowflake's Gen AI principles regarding data privacy, model usage, and governance in this scenario?
